const db = {
    wh_users: {
        id: "id",
        openid: "openid",
        score: "score",
        phone: "phone"
    },
    // 菜单表
    wh_menu: {
        id: "id",
        name: 'm_name',
        code: 'm_code',
        sort: 'm_sort',
        status: 'm_status',
        details: 'm_details'
    },
    // 类目表
    wh_category: {
        id: "id",
        name: "cg_name",
        code: "cg_code",
        level: "cg_level",
        status: "cg_status",
    },
    // 用户表
    user: {
        id: "id",
        name: "name",
        username: "username",
        password: "password",
        code: "code"
    },
    // 商品表
    wh_produce: {
        id: "id",
        name: "prod_name",
        details: "prod_details",
        header: "prod_header",
        price: "prod_price",
        bannerImgs: "prod_img",
        detailsImgs: "prod_imgs",
        category_id: "prod_category",
        menu_id: "prod_menu",
        appId: "prod_appId"
    },
    vw_produce: {
        id: "id",
        name: "prod_name",
        details: "prod_details",
        header: "prod_header",
        price: "prod_price",
        bannerImgs: "prod_img",
        detailsImgs: "prod_imgs",
        category_id: "prod_category",
        menu_id: "prod_menu",
        appId: "prod_appId",
        category_name: "cg_name",
        menu_name: "m_name",
    },
    wh_score: {
        id: "id",
        name: "prod_name",
        details: "prod_details",
        header: "prod_header",
        price: "prod_price",
        bannerImgs: "prod_img",
        detailsImgs: "prod_imgs",
        category_id: "prod_category",
        menu_id: "prod_menu",
        appId: "prod_appId"
    },
    vw_score: {
        id: "id",
        name: "prod_name",
        details: "prod_details",
        header: "prod_header",
        price: "prod_price",
        bannerImgs: "prod_img",
        detailsImgs: "prod_imgs",
        category_id: "prod_category",
        menu_id: "prod_menu",
        appId: "prod_appId",
        category_name: "cg_name",
        menu_name: "m_name",
    },
    wh_home: {
        id: "id",
        bgImg: "h_bgImg",
        QRCode: "h_QRCode",
        title: "h_title",
        list: "h_list"
    },
    wh_shop: {
        id: "id",
        produce_id: "o_prod",
        user_id: "o_user",
        code: "o_code",
        remark: "o_remark",
        time: "o_time",
        address: "o_address",
        status: "o_status",
        type: "o_type",
    },
    wh_order: {
        id: "id",
        produce_id: "o_prod",
        user_id: "o_user",
        code: "o_code",
        remark: "o_remark",
        time: "o_time",
        address: "o_address",
        status: "o_status",
        type: "o_type",
    },
    wh_shop_list: {
        id: "id",
        produce_id: "o_prod",
        code: "o_code",
        num: "o_num"
    },
    wh_order_list: {
        id: "id",
        produce_id: "o_prod",
        code: "o_code",
        num: "o_num"
    },
    vw_order: {
        id: "id",
        produce_id: "o_prod",
        user_id: "o_user",
        code: "o_code",
        time: "o_time",
        status: "o_status",
        num: "o_num",
        type: "o_type",
        produce_name: "prod_name",
        produce_details: "prod_details",
        produce_header: "prod_header",
        produce_menu: "prod_menu",
        produce_img: "prod_img",
        produce_imgs: "prod_imgs",
        produce_price: "prod_price",
    },
    vw_shop: {
        id: "id",
        produce_id: "o_prod",
        user_id: "o_user",
        code: "o_code",
        time: "o_time",
        status: "o_status",
        num: "o_num",
        type: "o_type",
        produce_name: "prod_name",
        produce_details: "prod_details",
        produce_header: "prod_header",
        produce_menu: "prod_menu",
        produce_img: "prod_img",
        produce_imgs: "prod_imgs",
        produce_price: "prod_price",
    },
    vw_order_score: {
        id: "id",
        produce_id: "o_prod",
        user_id: "o_user",
        code: "o_code",
        time: "o_time",
        status: "o_status",
        num: "o_num",
        type: "o_type",
        produce_name: "prod_name",
        produce_details: "prod_details",
        produce_header: "prod_header",
        produce_menu: "prod_menu",
        produce_img: "prod_img",
        produce_imgs: "prod_imgs",
        produce_price: "prod_price",
    },
    user_address: {
        id: "id",
        openid: "openid",
        link: "link",
        type: "type",
        address: "address",
        remark: "remark",
        area: "area",
        name: "name",
        isdef: "isdef"
    },
    wh_record: {
        openid: "openid",
        record: "record",
        status: "status"
    }
}
module.exports = db






